1. Procedure and function difference. 
2. Explain trigger      
3. Have developed Material view                    
4. Delete duplicate record 5.sum of last 10 days transaction                         
6. Performance tunning.7.rank and dense rank() difference                 
8. which techinque you will use for  fetching 10 millions records.               
9. in trigger what will happen in case of system cross or network.           
10.Listout analytical functions.                         
11.How to tune the query.                                
12.What is pragma automous transaction?? 
13.Persons allocated with more than one project.                             
14.How to handle exceptions when you process 10000 records.